CREATE TABLE [dbo].[TRSUSP_CUAR]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_PROV] [dbo].[TD_VC_020] NOT NULL,
[NU_ANNO_EJER] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TRSUSP_CU__NU_AN__76026BA8] DEFAULT ((0)),
[NU_SECU] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TRSUSP_CU__NU_SE__76F68FE1] DEFAULT ((0)),
[NU_SOLI_SUSP] [dbo].[TD_VC_020] NOT NULL,
[TI_MEDI_PRES] [dbo].[TD_VC_020] NULL,
[FE_PRES] [dbo].[TD_DT_001] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRSUSP_CU__CO_US__77EAB41A] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRSUSP_CU__FE_US__78DED853] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TRSUSP_CU__CO_US__79D2FC8C] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TRSUSP_CU__FE_US__7AC720C5] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRSUSP_CUAR] ADD CONSTRAINT [PK__TRSUSP_C__3EEBD0721A15AEEC] PRIMARY KEY CLUSTERED  ([CO_EMPR], [CO_PROV], [NU_ANNO_EJER], [NU_SECU]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TRSUSP_CUAR] ADD CONSTRAINT [FK__TRSUSP_CUAR__22CAF07E] FOREIGN KEY ([CO_EMPR], [CO_PROV]) REFERENCES [dbo].[TMPRES_SERV] ([CO_EMPR], [CO_PROV])
GO
